export const htmap = {
  allcpttnum:`
    SELECT ISUSE name,COUNT(ISUSE) value FROM SRC_CPTTS
      WHERE UID = ? GROUP BY ISUSE
    `,
  hiscpttnum:`
    SELECT ISUSE name,COUNT(ISUSE) value FROM src_hisevents
      WHERE UID = ? GROUP BY ISUSE
    `,
  getmycptt:`
    SELECT * FROM SRC_CPTTS WHERE UID = ? AND ISUSE = 1
    `,
  gethiscptt:`
    SELECT * FROM SRC_HISEVENTS WHERE UID=? AND ISUSE = 1
    `,
  addcptt:`
    INSERT INTO SRC_CPTTS 
    (UID,NAME,TYPE,URL,OVERTIME,GOINGTIME,INFO,REQUIREMENTS,ISSHOW)
    VALUES(?,?,?,?,?,?,?,?,?)`,
  selectdiscptt:`
    SELECT * FROM SRC_CPTTS
    WHERE ISUSE=0 AND UID = ?`,
  selectdishiscptt:`
    SELECT * FROM SRC_HISEVENTS
    WHERE ISUSE=0 AND UID = ?`,
  delcptt:`
    UPDATE SRC_CPTTS 
    SET ISUSE = 0 WHERE ID = ?`,
  recovercptt:`
    UPDATE SRC_CPTTS
    SET ISUSE = 1 WHERE ID = ?`,
  // selectone
  
}